'use strict';
/**
 * 创建 分类迁移文件
 * sequelize db:seed --seed 20240607040005-create-category
 * @type {import('sequelize-cli').Migration}
 * */
module.exports = {
	async up(queryInterface, Sequelize) {
		await queryInterface.createTable('Categories', {
			id: {
				allowNull: false,
				autoIncrement: true,
				primaryKey: true,
				type: Sequelize.INTEGER.UNSIGNED
			},
			name: {
				allowNull: false,
				type: Sequelize.STRING
			},
			rank: {
				allowNull: false,
				defaultValue: 1,
				type: Sequelize.INTEGER.UNSIGNED
			},
			createdAt: {
				allowNull: false,
				type: Sequelize.DATE
			},
			updatedAt: {
				allowNull: false,
				type: Sequelize.DATE
			}
		});
	},
	async down(queryInterface, Sequelize) {
		await queryInterface.dropTable('Categories');
	}
};